#Libraries
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.3 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.0
## ✔ purrr 1.0.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(httr)
library(jsonlite)##
## Attaching package: 'jsonlite'
##
## The following object is masked from 'package:purrr':
##
## flatten#retrieve the data from the provided URL: DOHMH New York City Restaurant Inspection Results
get_all_inspections <- function(url) {
all_inspections <- vector("list", length = 0)
loop_index <- 1
chunk_size <- 50000
DO_NEXT <- TRUE
while (DO_NEXT) {
message("Getting data, page ", loop_index)
all_inspections[[loop_index]] <-
GET(url,
query = list(`$order` = "zipcode",
`$limit` = chunk_size,
`$offset` = as.integer((loop_index - 1) * chunk_size)
)
) %>%
content("text") %>%
fromJSON() %>%
as_tibble()
DO_NEXT <- dim(all_inspections[[loop_index]])[1] == chunk_size
loop_index <- loop_index + 1
}
bind_rows(all_inspections)
}
url <- "https://data.cityofnewyork.us/resource/43nn-pn8j.json"
nyc_inspections <- get_all_inspections(url)## Getting data, page 1## Getting data, page 2## Getting data, page 3## Getting data, page 4## Getting data, page 5# Display column names
col_names <- names(nyc_inspections)
col_names## [1] "camis" "boro" "building"
## [4] "street" "zipcode" "phone"
## [7] "inspection_date" "critical_flag" "record_date"
## [10] "dba" "cuisine_description" "action"
## [13] "violation_code" "violation_description" "score"
## [16] "grade" "grade_date" "inspection_type"
## [19] "latitude" "longitude" "community_board"
## [22] "council_district" "census_tract" "bin"
## [25] "bbl" "nta"#Remove rows with missing observations (nyc_inspections_filtered)
# Remove rows with missing observations
nyc_inspections_filtered <- na.omit(nyc_inspections) #from 209,222 observations filtered down to 91,260#Now look at data for zipcode 10009
library(dplyr)
# Filter data for the specific zipcode (e.g., 10009)
nyc_inspections_zipcode <- nyc_inspections %>%
filter(zipcode == 10009)#remove 10009 data with missing observations
library(tidyr)
# Filter out rows with missing data
nyc_inspections_zipcode_clean <- drop_na(nyc_inspections_zipcode) #from 2283 observations to 943 observations#now combine building variable with street variable to get the address of the restaurants
# Create a new variable "address" by combining "building" and "street"
nyc_inspections_zipcode_clean <- nyc_inspections_zipcode_clean %>%
mutate(address = paste(building, street, sep = " "))
# View the updated df
head(nyc_inspections_zipcode_clean)## # A tibble: 6 × 27
## camis boro building street zipcode phone inspection_date critical_flag
## <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
## 1 50069033 Manhattan 111 EAST … 10009 2127… 2023-06-02T00:… Not Critical
## 2 41375676 Manhattan 188 AVENU… 10009 2122… 2022-12-28T00:… Critical
## 3 50104748 Manhattan 214 1 AVE… 10009 2122… 2022-01-25T00:… Not Critical
## 4 50117265 Manhattan 149 AVENU… 10009 3474… 2021-12-15T00:… Not Critical
## 5 41264019 Manhattan 33 AVENU… 10009 2122… 2023-03-25T00:… Not Critical
## 6 50108847 Manhattan 150 EAST … 10009 2123… 2023-09-20T00:… Critical
## # ℹ 19 more variables: record_date <chr>, dba <chr>, cuisine_description <chr>,
## # action <chr>, violation_code <chr>, violation_description <chr>,
## # score <chr>, grade <chr>, grade_date <chr>, inspection_type <chr>,
## # latitude <chr>, longitude <chr>, community_board <chr>,
## # council_district <chr>, census_tract <chr>, bin <chr>, bbl <chr>,
## # nta <chr>, address <chr>#convert tiblle into a normal df
# Convert tibble to data frame
nyc_inspections_zipcode_clean_df <- as.data.frame(nyc_inspections_zipcode_clean)
# View the resulting data frame
head(nyc_inspections_zipcode_clean_df)## camis boro building street zipcode phone
## 1 50069033 Manhattan 111 EAST 7 STREET 10009 2127772017
## 2 41375676 Manhattan 188 AVENUE A 10009 2122545660
## 3 50104748 Manhattan 214 1 AVENUE 10009 2122532990
## 4 50117265 Manhattan 149 AVENUE A 10009 3474846694
## 5 41264019 Manhattan 33 AVENUE B 10009 2122284461
## 6 50108847 Manhattan 150 EAST 3 STREET 10009 2123912870
## inspection_date critical_flag record_date
## 1 2023-06-02T00:00:00.000 Not Critical 2023-11-20T06:00:07.000
## 2 2022-12-28T00:00:00.000 Critical 2023-11-20T06:00:07.000
## 3 2022-01-25T00:00:00.000 Not Critical 2023-11-20T06:00:07.000
## 4 2021-12-15T00:00:00.000 Not Critical 2023-11-20T06:00:07.000
## 5 2023-03-25T00:00:00.000 Not Critical 2023-11-20T06:00:07.000
## 6 2023-09-20T00:00:00.000 Critical 2023-11-20T06:00:07.000
## dba cuisine_description
## 1 LADYBIRD Vegetarian
## 2 AU ZA'ATAR American
## 3 TALLGRASS BURGER Hamburgers
## 4 BLANK STREET Coffee/Tea
## 5 POCO Spanish
## 6 DAVIDOVICH BAKERY Bagels/Pretzels
## action violation_code
## 1 Violations were cited in the following area(s). 10F
## 2 Violations were cited in the following area(s). 04L
## 3 Violations were cited in the following area(s). 10F
## 4 Violations were cited in the following area(s). 10B
## 5 Violations were cited in the following area(s). 10F
## 6 Violations were cited in the following area(s). 04N
## violation_description
## 1 Non-food contact surface or equipment made of unacceptable material, not kept clean, or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.
## 2 Evidence of mice or live mice in establishment's food or non-food areas.
## 3 Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.
## 4 Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly.
## 5 Non-food contact surface or equipment made of unacceptable material, not kept clean, or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.
## 6 Filth flies or food/refuse/sewage associated with (FRSA) flies or other nuisance pests in establishment’s food and/or non-food areas. FRSA flies include house flies, blow flies, bottle flies, flesh flies, drain flies, Phorid flies and fruit flies.
## score grade grade_date
## 1 10 A 2023-06-02T00:00:00.000
## 2 13 A 2022-12-28T00:00:00.000
## 3 9 A 2022-01-25T00:00:00.000
## 4 12 A 2021-12-15T00:00:00.000
## 5 3 A 2023-03-25T00:00:00.000
## 6 18 Z 2023-09-20T00:00:00.000
## inspection_type latitude
## 1 Cycle Inspection / Initial Inspection 40.726568807391
## 2 Cycle Inspection / Re-inspection 40.72892332511
## 3 Pre-permit (Operational) / Re-inspection 40.730496344655
## 4 Pre-permit (Operational) / Initial Inspection 40.727463280994
## 5 Cycle Inspection / Initial Inspection 40.7225118046
## 6 Cycle Inspection / Re-inspection 40.723489203257
## longitude community_board council_district census_tract bin
## 1 -73.984760220316 103 02 003200 1005849
## 2 -73.981425859683 103 02 003400 1005166
## 3 -73.983168139519 103 02 003400 1005982
## 4 -73.982515869421 103 02 003400 1076870
## 5 -73.983065541094 103 02 002202 1004589
## 6 -73.984941314011 103 02 003002 1004965
## bbl nta address
## 1 1004350045 MN22 111 EAST 7 STREET
## 2 1004050008 MN22 188 AVENUE A
## 3 1004400008 MN22 214 1 AVENUE
## 4 1004370029 MN22 149 AVENUE A
## 5 1003850005 MN28 33 AVENUE B
## 6 1003980006 MN22 150 EAST 3 STREET#load libraries I will need for these fancy plots
#install.packages("plotly")
library(tidyverse)
library(plotly)##
## Attaching package: 'plotly'## The following object is masked from 'package:httr':
##
## config## The following object is masked from 'package:ggplot2':
##
## last_plot## The following object is masked from 'package:stats':
##
## filter## The following object is masked from 'package:graphics':
##
## layoutlibrary(dplyr)#scatter plot like the lecture
# Create the scatter plot
nyc_inspections_zipcode_clean_df %>%
plot_ly(
x = ~latitude,
y = ~longitude,
type = "scatter",
mode = "markers",
color = ~grade, # Assuming "grade" is a categorical variable
text = ~paste("Grade: ", grade),
alpha = 0.5
) %>%
layout(
title = "NYC Restaurant Inspection Grades",
xaxis = list(title = "Latitude"),
yaxis = list(title = "Longitude")
)#That plot is gross…lets try grade vs. street
plot_ly(
data = nyc_inspections_zipcode_clean_df,
x = ~street,
y = ~grade,
type = "scatter",
mode = "markers",
text = ~paste("Grade: ", grade, "<br>Street: ", street),
marker = list(size = 10, color = ~grade)
) %>%
layout(title = "Grade vs Street",
xaxis = list(title = "Street"),
yaxis = list(title = "Grade"))#googled how to add color to grades
plot_ly(
data = nyc_inspections_zipcode_clean_df,
x = ~street,
y = ~grade,
type = "scatter",
mode = "markers",
text = ~paste("Grade: ", grade, "<br>Street: ", street),
color = ~grade,
colors = c("A" = "green", "B" = "blue", "C" = "orange", "P" = "purple", "Z" = "red"),
marker = list(size = 10)
) %>%
layout(title = "Grade vs Street",
xaxis = list(title = "Street"),
yaxis = list(title = "Grade"))#list all restuarant names and addressed if they have an A
library(dplyr)
# Filter the data for grade A
grade_A_data <- nyc_inspections_zipcode_clean_df %>%
filter(grade == "A")
# Create a table of restaurant names (dba), their locations (address),
# grade, and inspection date
restaurant_table <- grade_A_data %>%
select(dba, address, grade, inspection_date)
# Arrange the table alphabetically by restaurant names
restaurant_table <- arrange(restaurant_table, dba)
# Print the sorted table
print(restaurant_table)## dba address grade
## 1 11TH ST BAR 510 EAST 11 STREET A
## 2 11TH ST BAR 510 EAST 11 STREET A
## 3 11TH ST BAR 510 EAST 11 STREET A
## 4 11TH ST BAR 510 EAST 11 STREET A
## 5 11TIGERS 225 AVENUE B A
## 6 11TIGERS 225 AVENUE B A
## 7 2A 25 AVENUE A A
## 8 5C CAFE & CULTURAL CENTER 68 AVENUE C A
## 9 787 COFFEE 131 EAST 7 STREET A
## 10 787 COFFEE 131 EAST 7 STREET A
## 11 7B BAR 108 AVENUE B A
## 12 7B BAR 108 AVENUE B A
## 13 7B BAR 108 AVENUE B A
## 14 7th STREET BURGER 91 EAST 7 STREET A
## 15 7th STREET BURGER 91 EAST 7 STREET A
## 16 7th STREET BURGER 91 EAST 7 STREET A
## 17 7th STREET BURGER 91 EAST 7 STREET A
## 18 7th STREET BURGER 91 EAST 7 STREET A
## 19 96 TEARS 110 AVENUE A A
## 20 96 TEARS 110 AVENUE A A
## 21 99 CENTS FRESH PIZZA & HOT DOG 131 AVENUE A A
## 22 99 CENTS FRESH PIZZA & HOT DOG 131 AVENUE A A
## 23 A & C KITCHEN 134-136 AVENUE C A
## 24 A & C KITCHEN 134-136 AVENUE C A
## 25 A'MORE CAFFE 150 EAST 2 STREET A
## 26 A'MORE CAFFE 150 EAST 2 STREET A
## 27 ABC BEER CO. 96 AVENUE C A
## 28 ACCIDENTAL BAR 98 AVENUE C A
## 29 ACE BAR 531 EAST 5 STREET A
## 30 ACE BAR 531 EAST 5 STREET A
## 31 ALL THE KINGS HORSES CAFE 521 EAST 12 STREET A
## 32 ALL THE KINGS HORSES CAFE 521 EAST 12 STREET A
## 33 ALL THE KINGS HORSES CAFE 521 EAST 12 STREET A
## 34 ALPHABET 99 CENTS FRESH PIZZA 20 AVENUE A A
## 35 ALPHABET 99 CENTS FRESH PIZZA 20 AVENUE A A
## 36 ALPHABET 99 CENTS FRESH PIZZA 20 AVENUE A A
## 37 AMA RAW BAR 190 AVENUE B A
## 38 AMA RAW BAR 190 AVENUE B A
## 39 AMA RAW BAR 190 AVENUE B A
## 40 AMA RAW BAR 190 AVENUE B A
## 41 AMA RAW BAR 190 AVENUE B A
## 42 AMA RAW BAR 190 AVENUE B A
## 43 AMOR Y AMARGO/ CAFE DE L'ENFER 95 AVENUE A A
## 44 AMOR Y AMARGO/ CAFE DE L'ENFER 95 AVENUE A A
## 45 APPAS PIZZA 210 1 AVENUE A
## 46 APPAS PIZZA 210 1 AVENUE A
## 47 APPAS PIZZA 210 1 AVENUE A
## 48 ASIAN TASTE 199 EAST 3 STREET A
## 49 ASIAN TASTE 199 EAST 3 STREET A
## 50 AU ZA'ATAR 188 AVENUE A A
## 51 AU ZA'ATAR 188 AVENUE A A
## 52 AU ZA'ATAR 188 AVENUE A A
## 53 AUGURS WELL 115 ST MARKS PLACE A
## 54 AUGURS WELL 115 ST MARKS PLACE A
## 55 AUGURS WELL 115 ST MARKS PLACE A
## 56 AVANT GARDEN 130 EAST 7 STREET A
## 57 AVANT GARDEN 130 EAST 7 STREET A
## 58 AVANT GARDEN 130 EAST 7 STREET A
## 59 AVANT GARDEN 130 EAST 7 STREET A
## 60 AVANT GARDEN 130 EAST 7 STREET A
## 61 B CUP CAFE 212 AVENUE B A
## 62 B CUP CAFE 212 AVENUE B A
## 63 B CUP CAFE 212 AVENUE B A
## 64 B-SIDE 204 AVENUE B A
## 65 BAKER'S PIZZA 201 AVENUE A A
## 66 BAKER'S PIZZA 201 AVENUE A A
## 67 BALADE 208 1 AVENUE A
## 68 BALADE 208 1 AVENUE A
## 69 BALADE 208 1 AVENUE A
## 70 BALADE 208 1 AVENUE A
## 71 BANH MI ZON 443 EAST 6 STREET A
## 72 BANH MI ZON 443 EAST 6 STREET A
## 73 BANH MI ZON 443 EAST 6 STREET A
## 74 BAR LULA 132 1 AVENUE A
## 75 BAR LULA 132 1 AVENUE A
## 76 BAR MILLER 620 EAST 6 STREET A
## 77 BAR MILLER 620 EAST 6 STREET A
## 78 BAR MILLER 620 EAST 6 STREET A
## 79 BEDLAM 40 AVENUE C A
## 80 BEDLAM 40 AVENUE C A
## 81 BEDLAM 40 AVENUE C A
## 82 BEDLAM 40 AVENUE C A
## 83 BEDLAM 40 AVENUE C A
## 84 BEDLAM 40 AVENUE C A
## 85 BEDLAM 40 AVENUE C A
## 86 BEDLAM 40 AVENUE C A
## 87 BIBI WINECELLAR 211 EAST 4 STREET A
## 88 BIBI WINECELLAR 211 EAST 4 STREET A
## 89 BIBI WINECELLAR 211 EAST 4 STREET A
## 90 BIBI WINECELLAR 211 EAST 4 STREET A
## 91 BIN141 43 AVENUE A A
## 92 BIN141 43 AVENUE A A
## 93 BIN141 43 AVENUE A A
## 94 BIN141 43 AVENUE A A
## 95 BIN141 43 AVENUE A A
## 96 BLACK SEED BAGELS 176 1 AVENUE A
## 97 BLACK SEED BAGELS 176 1 AVENUE A
## 98 BLACK SEED BAGELS 176 1 AVENUE A
## 99 BLANK STREET 149 AVENUE A A
## 100 BLANK STREET 149 AVENUE A A
## 101 BLANK STREET 149 AVENUE A A
## 102 BLANK STREET 149 AVENUE A A
## 103 BOBBY'S NIGHT OUT 145 AVENUE C A
## 104 BOBBY'S NIGHT OUT 145 AVENUE C A
## 105 BOBBY'S NIGHT OUT 145 AVENUE C A
## 106 BOBWHITE COUNTER. 94 AVENUE C A
## 107 BOOK CLUB 197 EAST 3 STREET A
## 108 BOOK CLUB 197 EAST 3 STREET A
## 109 BOOK CLUB 197 EAST 3 STREET A
## 110 BORIS & HORTON 195 AVENUE A A
## 111 BORIS & HORTON 195 AVENUE A A
## 112 BORIS & HORTON 195 AVENUE A A
## 113 BORIS & HORTON 195 AVENUE A A
## 114 BORIS & HORTON 195 AVENUE A A
## 115 BOULTON & WATT 5 AVENUE A A
## 116 BOULTON & WATT 5 AVENUE A A
## 117 BOULTON & WATT 5 AVENUE A A
## 118 BREAD STORY 264 1 AVENUE A
## 119 BREAD STORY 264 1 AVENUE A
## 120 BREAD STORY 264 1 AVENUE A
## 121 BREAD STORY 264 1 AVENUE A
## 122 BRINDLE ROOM 647 EAST 11 STREET A
## 123 BRINDLE ROOM 647 EAST 11 STREET A
## 124 BRINDLE ROOM 647 EAST 11 STREET A
## 125 BRINDLE ROOM 647 EAST 11 STREET A
## 126 BUA 122-126 ST MARKS PLACE A
## 127 BUA 122-126 ST MARKS PLACE A
## 128 BURRATA PIZZA 221 AVENUE A A
## 129 BURRATA PIZZA 221 AVENUE A A
## 130 BURRATA PIZZA 221 AVENUE A A
## 131 C & B 178 EAST 7 STREET A
## 132 CADENCE 111 EAST 7 STREET A
## 133 CADENCE 111 EAST 7 STREET A
## 134 CAFE HIMALAYA 78 EAST 1 STREET A
## 135 CAFE HIMALAYA 78 EAST 1 STREET A
## 136 CAFE HIMALAYA 78 EAST 1 STREET A
## 137 CAFE HIMALAYA 78 EAST 1 STREET A
## 138 CAFE HIMALAYA 78 EAST 1 STREET A
## 139 CAFE JOAH 212 AVENUE A A
## 140 CAFE JOAH 212 AVENUE A A
## 141 CAFE MOGADOR 101 ST MARKS PLACE A
## 142 CAFE MOGADOR 101 ST MARKS PLACE A
## 143 CAFE MOGADOR 101 ST MARKS PLACE A
## 144 CAFE MOGADOR 101 ST MARKS PLACE A
## 145 CAFE MOGADOR 101 ST MARKS PLACE A
## 146 CAGEN 414 EAST 9 STREET A
## 147 CAGEN 414 EAST 9 STREET A
## 148 CAGEN 414 EAST 9 STREET A
## 149 CAGEN 414 EAST 9 STREET A
## 150 CALETA 131 AVENUE A A
## 151 CALETA 131 AVENUE A A
## 152 CARAVAN OF DREAMS 405 EAST 6 STREET A
## 153 CARAVAN OF DREAMS 405 EAST 6 STREET A
## 154 CARAVAN OF DREAMS 405 EAST 6 STREET A
## 155 CARAVAN OF DREAMS 405 EAST 6 STREET A
## 156 CARAVAN OF DREAMS 405 EAST 6 STREET A
## 157 CASA ADELA RESTAURANT 66 AVENUE C A
## 158 CB HOSPITALITY AND EVENTS 235 EAST 4 STREET A
## 159 CHERRY TAVERN 441 EAST 6 STREET A
## 160 CHINA WOK KITCHEN 63 AVENUE D A
## 161 CHINA WOK KITCHEN 63 AVENUE D A
## 162 CHINA WOK KITCHEN 63 AVENUE D A
## 163 CHINA WOK KITCHEN 63 AVENUE D A
## 164 CHINA WOK KITCHEN 63 AVENUE D A
## 165 CHIPOTLE MEXICAN GRILL 286 1 AVENUE A
## 166 CHIPOTLE MEXICAN GRILL 286 1 AVENUE A
## 167 COMPILATION COFFEE 102 SAINT MARKS PLACE A
## 168 CRIF DOGS 113 SAINT MARKS PLACE A
## 169 CRIF DOGS 113 SAINT MARKS PLACE A
## 170 CROWN FRIED CHICKEN 117 AVENUE D A
## 171 DA RADDA 127 EAST 7 STREET A
## 172 DAVID'S CAFE 110 SAINT MARKS PLACE A
## 173 DAVID'S CAFE 110 SAINT MARKS PLACE A
## 174 DAVIDOVICH BAKERY 150 EAST 3 STREET A
## 175 DAVIDOVICH BAKERY 150 EAST 3 STREET A
## 176 DAVIDOVICH BAKERY 150 EAST 3 STREET A
## 177 DEATH AND COMPANY 433 EAST 6 STREET A
## 178 DHOM 505 EAST 12 STREET A
## 179 DHOM 505 EAST 12 STREET A
## 180 DHOM 505 EAST 12 STREET A
## 181 DING-A-LING (THE THIRD MAN) 116 AVENUE C A
## 182 DOC HOLIDAYS 141 AVENUE A A
## 183 DOC HOLIDAYS 141 AVENUE A A
## 184 DOC HOLIDAYS 141 AVENUE A A
## 185 DOC HOLIDAYS 141 AVENUE A A
## 186 DOC HOLIDAYS 141 AVENUE A A
## 187 DOMINO'S 440 EAST 14 STREET A
## 188 DOMINO'S 440 EAST 14 STREET A
## 189 DOMINO'S 440 EAST 14 STREET A
## 190 DOMINO'S 440 EAST 14 STREET A
## 191 DOUBLE DOWN SALOON 14 AVENUE A A
## 192 DOUBLE DOWN SALOON 14 AVENUE A A
## 193 DOUBLE DOWN SALOON 14 AVENUE A A
## 194 DOUBLE DOWN SALOON 14 AVENUE A A
## 195 DREAM BABY 162 AVENUE B A
## 196 DREAM BABY 162 AVENUE B A
## 197 DREAM BABY 162 AVENUE B A
## 198 DROM 85 AVENUE A A
## 199 DROM 85 AVENUE A A
## 200 DROP OFF SERVICE 211 AVENUE A A
## 201 DROP OFF SERVICE 211 AVENUE A A
## 202 DROP OFF SERVICE 211 AVENUE A A
## 203 DUA KAFE 520 EAST 14 STREET A
## 204 DUA KAFE 520 EAST 14 STREET A
## 205 DUA KAFE 520 EAST 14 STREET A
## 206 DUA KAFE 520 EAST 14 STREET A
## 207 DUA KAFE 520 EAST 14 STREET A
## 208 DUNKIN 266 1 AVENUE A
## 209 DUNKIN 266 1 AVENUE A
## 210 DUNKIN 266 1 AVENUE A
## 211 DUNKIN 266 1 AVENUE A
## 212 DUNKIN , BASKIN ROBBINS 100 1 AVENUE A
## 213 DUNKIN , BASKIN ROBBINS 100 1 AVENUE A
## 214 DUNKIN , BASKIN ROBBINS 100 1 AVENUE A
## 215 DUNKIN , BASKIN ROBBINS 100 1 AVENUE A
## 216 DUNKIN , BASKIN ROBBINS 100 1 AVENUE A
## 217 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 218 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 219 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 220 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 221 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 222 DUNKIN',' BASKIN ROBBINS 542 EAST 14 STREET A
## 223 EASTERN BLOC , Club Cumming 505 EAST 6 STREET A
## 224 EASTPOINT/DOWNTIME 25 AVENUE B A
## 225 EASTPOINT/DOWNTIME 25 AVENUE B A
## 226 EASTPOINT/DOWNTIME 25 AVENUE B A
## 227 EASTPOINT/DOWNTIME 25 AVENUE B A
## 228 EASTPOINT/DOWNTIME 25 AVENUE B A
## 229 EASTSIDE STORY 265 EAST 10 STREET A
## 230 EASTSIDE STORY 265 EAST 10 STREET A
## 231 ELEVEN B 174 AVENUE B A
## 232 ELEVEN B 174 AVENUE B A
## 233 ELEVEN B 174 AVENUE B A
## 234 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 235 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 236 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 237 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 238 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 239 ELISA'S LOVE BITES 441 EAST 9 STREET A
## 240 EMPELLON AL PASTOR 132 SAINT MARKS PLACE A
## 241 EMPELLON AL PASTOR 132 SAINT MARKS PLACE A
## 242 EMPELLON AL PASTOR 132 SAINT MARKS PLACE A
## 243 EMPELLON AL PASTOR 132 SAINT MARKS PLACE A
## 244 EMPELLON AL PASTOR 132 SAINT MARKS PLACE A
## 245 ESS-A-BAGEL 324 1 AVENUE A
## 246 ESS-A-BAGEL 324 1 AVENUE A
## 247 ESS-A-BAGEL 324 1 AVENUE A
## 248 EVERYTABLE 229 AVENUE B A
## 249 EVERYTABLE 229 AVENUE B A
## 250 EVIL KATSU 435 EAST 9 STREET A
## 251 FAMOUS & FRESH 99¢ PIZZA 91 AVENUE A A
## 252 FAMOUS & FRESH 99¢ PIZZA 91 AVENUE A A
## 253 FAMOUS & FRESH 99¢ PIZZA 91 AVENUE A A
## 254 FEI MA 79 AVENUE A A
## 255 FEI MA 79 AVENUE A A
## 256 FEI MA 79 AVENUE A A
## 257 FIASCHETTERIA PISTOIA 647 EAST 11 STREET A
## 258 FIASCHETTERIA PISTOIA 647 EAST 11 STREET A
## 259 FISHMARKET II 171 AVENUE A A
## 260 FISHMARKET II 171 AVENUE A A
## 261 FISHMARKET II 171 AVENUE A A
## 262 FIVESTUY CAFE 5 STUYVESANT OVAL A
## 263 FIVESTUY CAFE 5 STUYVESANT OVAL A
## 264 FRANGO PERI PERI 182 AVENUE B A
## 265 FRANGO PERI PERI 182 AVENUE B A
## 266 FRANGO PERI PERI 182 AVENUE B A
## 267 FRESNO II GOURMET DELI 31 AVENUE C A
## 268 FRESNO II GOURMET DELI 31 AVENUE C A
## 269 GENA'S GRILL 210 1 AVENUE A
## 270 GENA'S GRILL 210 1 AVENUE A
## 271 GENA'S GRILL 210 1 AVENUE A
## 272 GIANO 126 EAST 7 STREET A
## 273 GIANO 126 EAST 7 STREET A
## 274 GIANO 126 EAST 7 STREET A
## 275 GNOCCHERIA BY LUZZO'S 234 EAST 4 STREET A
## 276 GNOCCHERIA BY LUZZO'S 234 EAST 4 STREET A
## 277 GNOCCHERIA BY LUZZO'S 234 EAST 4 STREET A
## 278 GNOCCO 337 EAST 10 STREET A
## 279 GOMI-WINE-FOOD-FRIENDS 186 AVENUE A A
## 280 GOMI-WINE-FOOD-FRIENDS 186 AVENUE A A
## 281 GOMI-WINE-FOOD-FRIENDS 186 AVENUE A A
## 282 GOOD NIGHT SONNY 134 1 AVENUE A
## 283 GOOD NIGHT SONNY 134 1 AVENUE A
## 284 GOOD NIGHT SONNY 134 1 AVENUE A
## 285 GOOD NIGHT SONNY 134 1 AVENUE A
## 286 GOOD NIGHT SONNY 134 1 AVENUE A
## 287 GRUPPO 98 AVENUE B A
## 288 GRUPPO 98 AVENUE B A
## 289 GRUPPO 98 AVENUE B A
## 290 GRUPPO 98 AVENUE B A
## 291 GRUPPO 98 AVENUE B A
## 292 HAILE BISTRO 182 AVENUE B A
## 293 HAILE BISTRO 182 AVENUE B A
## 294 HAILE BISTRO 182 AVENUE B A
## 295 HANE SUSHI 346 1 AVENUE A
## 296 HANE SUSHI 346 1 AVENUE A
## 297 HANOI HOUSE 119 SAINT MARKS PLACE A
## 298 HANOI HOUSE 119 SAINT MARKS PLACE A
## 299 HANOI HOUSE 119 SAINT MARKS PLACE A
## 300 HAPPY WOK 175 AVENUE C A
## 301 HAPPY WOK 175 AVENUE C A
## 302 HAPPY WOK 175 AVENUE C A
## 303 HAPPY WOK 175 AVENUE C A
## 304 HAWA SMOOTHIE 422 EAST 14 STREET A
## 305 HAWA SMOOTHIE 422 EAST 14 STREET A
## 306 HAWA SMOOTHIE 422 EAST 14 STREET A
## 307 HAWA SMOOTHIE 422 EAST 14 STREET A
## 308 HEARTH 403 EAST 12 STREET A
## 309 HEARTH 403 EAST 12 STREET A
## 310 HEARTH 403 EAST 12 STREET A
## 311 HEAVEN CAN WAIT 169 AVENUE A A
## 312 HEAVEN CAN WAIT 169 AVENUE A A
## 313 HEAVEN CAN WAIT 169 AVENUE A A
## 314 HI-NOTE 188 AVENUE B A
## 315 HI-NOTE 188 AVENUE B A
## 316 HO FOODS NYC 110 EAST 7 STREET A
## 317 HORUS CAFE 293 EAST 10 STREET A
## 318 HORUS CAFE 293 EAST 10 STREET A
## 319 HORUS KEBAB HOUSE 93 AVENUE B A
## 320 HORUS KEBAB HOUSE 93 AVENUE B A
## 321 HORUS KEBAB HOUSE 93 AVENUE B A
## 322 HORUS KEBAB HOUSE 93 AVENUE B A
## 323 HORUS KEBAB HOUSE 93 AVENUE B A
## 324 HUB THAI 50 AVENUE A A
## 325 HUB THAI 50 AVENUE A A
## 326 HUB THAI 50 AVENUE A A
## 327 HUB THAI 50 AVENUE A A
## 328 HUB THAI 50 AVENUE A A
## 329 HUNAN SLURP SHOP 112 1 AVENUE A
## 330 HUNAN SLURP SHOP 112 1 AVENUE A
## 331 Hibachi Express 536 EAST 14 STREET A
## 332 Hibachi Express 536 EAST 14 STREET A
## 333 Hibachi Express 536 EAST 14 STREET A
## 334 Hibachi Express 536 EAST 14 STREET A
## 335 Hibachi Express 536 EAST 14 STREET A
## 336 Hibachi Express 536 EAST 14 STREET A
## 337 Hibachi Express 536 EAST 14 STREET A
## 338 IL POSTO ACCANTO 190 EAST 2 STREET A
## 339 IL POSTO ACCANTO 190 EAST 2 STREET A
## 340 IL POSTO ACCANTO 190 EAST 2 STREET A
## 341 IL POSTO ACCANTO 190 EAST 2 STREET A
## 342 IL POSTO ACCANTO 190 EAST 2 STREET A
## 343 INTERNATIONAL BAR 102 1 AVENUE A
## 344 INTERNATIONAL BAR 102 1 AVENUE A
## 345 JELL & CHILL 110 EAST 7 STREET A
## 346 JELL & CHILL 110 EAST 7 STREET A
## 347 JOSIE'S BAR 520 EAST 6 STREET A
## 348 JOYFACE 104 AVENUE C A
## 349 JUICY LUCY 85 AVENUE A A
## 350 JUICY LUCY 85 AVENUE A A
## 351 KAFANA 116 AVENUE C A
## 352 KAFANA 116 AVENUE C A
## 353 KAFANA 116 AVENUE C A
## 354 KAFANA 116 AVENUE C A
## 355 KAZUZA 107 AVENUE A A
## 356 KAZUZA 107 AVENUE A A
## 357 KAZUZA 107 AVENUE A A
## 358 KAZUZA 107 AVENUE A A
## 359 KELLY'S 12 AVENUE A A
## 360 KELLY'S 12 AVENUE A A
## 361 KELLY'S 12 AVENUE A A
## 362 KELLY'S 12 AVENUE A A
## 363 KOBO BY NAI 202 AVENUE A A
## 364 KOBO BY NAI 202 AVENUE A A
## 365 KOKO SUSHI 214 1 AVENUE A
## 366 KOKO SUSHI 214 1 AVENUE A
## 367 KOKO WINGS 192 1 AVENUE A
## 368 KOKO WINGS 192 1 AVENUE A
## 369 KOKO WINGS 192 1 AVENUE A
## 370 KOKO WINGS 192 1 AVENUE A
## 371 KOKO WINGS 192 1 AVENUE A
## 372 LADYBIRD 111 EAST 7 STREET A
## 373 LADYBIRD 111 EAST 7 STREET A
## 374 LADYBIRD 111 EAST 7 STREET A
## 375 LADYBIRD 111 EAST 7 STREET A
## 376 LAVAGNA 545 EAST 5 STREET A
## 377 LAVAGNA 545 EAST 5 STREET A
## 378 LE PHIN 259 EAST 10 STREET A
## 379 LENZ'S 514 EAST 20 STREET A
## 380 LENZ'S 514 EAST 20 STREET A
## 381 LENZ'S 514 EAST 20 STREET A
## 382 LENZ'S 514 EAST 20 STREET A
## 383 LENZ'S 514 EAST 20 STREET A
## 384 LEON'S CAFE 274 EAST 3 STREET A
## 385 LEON'S CAFE 274 EAST 3 STREET A
## 386 LEON'S CAFE 274 EAST 3 STREET A
## 387 LITTLE GIO'S PIZZA 26 1 AVENUE A
## 388 LITTLE GIO'S PIZZA 26 1 AVENUE A
## 389 LLAMA@THEPARK 75 EAST 1 STREET A
## 390 LLAMA@THEPARK 75 EAST 1 STREET A
## 391 LLAMA@THEPARK 75 EAST 1 STREET A
## 392 LUCIEN 14 1 AVENUE A
## 393 LUCIEN 14 1 AVENUE A
## 394 LUCIEN 14 1 AVENUE A
## 395 LUCKY 168 AVENUE B A
## 396 LUCKY 168 AVENUE B A
## 397 LUCKY 168 AVENUE B A
## 398 LUCKY 168 AVENUE B A
## 399 LUCYS 135 AVENUE A A
## 400 LUCYS 135 AVENUE A A
## 401 LUCYS 135 AVENUE A A
## 402 LUCYS 135 AVENUE A A
## 403 LUCYS 135 AVENUE A A
## 404 M & J ASIAN RESTAURANT 600 EAST 14 STREET A
## 405 M & J ASIAN RESTAURANT 600 EAST 14 STREET A
## 406 M & J ASIAN RESTAURANT 600 EAST 14 STREET A
## 407 MAIDEN LANE 162 AVENUE B A
## 408 MAIDEN LANE 162 AVENUE B A
## 409 MALA PROJECT 122 1 AVENUE A
## 410 MALA PROJECT 122 1 AVENUE A
## 411 MALA PROJECT 122 1 AVENUE A
## 412 MALA PROJECT 122 1 AVENUE A
## 413 MALA PROJECT 122 1 AVENUE A
## 414 MALA PROJECT 122 1 AVENUE A
## 415 MALA PROJECT 122 1 AVENUE A
## 416 MALA PROJECT 122 1 AVENUE A
## 417 MAMA'S BAR 34 AVENUE B A
## 418 MARY O'S 32 AVENUE A A
## 419 MARY O'S 32 AVENUE A A
## 420 MARY O'S 32 AVENUE A A
## 421 MAYANOKI 620 EAST 6 STREET A
## 422 MAYANOKI 620 EAST 6 STREET A
## 423 MCDONALD'S 404 EAST 14 STREET A
## 424 MCDONALD'S 102 1 AVENUE A
## 425 MCDONALD'S 404 EAST 14 STREET A
## 426 MCDONALD'S 404 EAST 14 STREET A
## 427 MCDONALD'S 404 EAST 14 STREET A
## 428 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 429 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 430 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 431 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 432 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 433 MINCA RAMEN FACTORY 536 EAST 5 STREET A
## 434 MISS LILY'S 7A 109 AVENUE A A
## 435 MISS LILY'S 7A 109 AVENUE A A
## 436 MOCHII 116 EAST 7 STREET A
## 437 MOCHII 116 EAST 7 STREET A
## 438 MOCHII 116 EAST 7 STREET A
## 439 MOCHII 116 EAST 7 STREET A
## 440 MOKYO 109 SAINT MARKS PLACE A
## 441 MOKYO 109 SAINT MARKS PLACE A
## 442 MOKYO 109 SAINT MARKS PLACE A
## 443 MOKYO 109 SAINT MARKS PLACE A
## 444 MOKYO 109 SAINT MARKS PLACE A
## 445 MOKYO 109 SAINT MARKS PLACE A
## 446 MONA'S 224 AVENUE B A
## 447 MONA'S 224 AVENUE B A
## 448 MONA'S 224 AVENUE B A
## 449 MURPHY'S DOOR CAFE 440 EAST 9 STREET A
## 450 MURPHY'S DOOR CAFE 440 EAST 9 STREET A
## 451 NEW YORK TASTY PIZZA 418 EAST 14 STREET A
## 452 NEW YORK TASTY PIZZA 418 EAST 14 STREET A
## 453 NIAGARA / SISTER MIDNIGHT 112 AVENUE A A
## 454 NIAGARA / SISTER MIDNIGHT 112 AVENUE A A
## 455 NIAGARA / SISTER MIDNIGHT 112 AVENUE A A
## 456 NINTH STREET ESPRESSO 341 EAST 10 STREET A
## 457 NINTH STREET ESPRESSO 341 EAST 10 STREET A
## 458 NINTH STREET ESPRESSO 700 EAST 9 STREET A
## 459 NINTH STREET ESPRESSO 700 EAST 9 STREET A
## 460 NINTH STREET ESPRESSO 700 EAST 9 STREET A
## 461 NINTH STREET ESPRESSO 341 EAST 10 STREET A
## 462 NOREETUH 128 1 AVENUE A
## 463 NOWON 507 EAST 6 STREET A
## 464 NOWON 507 EAST 6 STREET A
## 465 NOWON 507 EAST 6 STREET A
## 466 NY SAL'S PIZZA 536 EAST 14 STREET A
## 467 NY SAL'S PIZZA 536 EAST 14 STREET A
## 468 ONE AND ONE 12 1 AVENUE A
## 469 ONE AND ONE 12 1 AVENUE A
## 470 OTTO'S SHRUNKEN HEAD 538 EAST 14 STREET A
## 471 OTTO'S SHRUNKEN HEAD 538 EAST 14 STREET A
## 472 OTTO'S SHRUNKEN HEAD 538 EAST 14 STREET A
## 473 PARDON MY FRENCH 103 AVENUE B A
## 474 PARDON MY FRENCH 103 AVENUE B A
## 475 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 476 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 477 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 478 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 479 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 480 PERK COFFEE 14TH ST 534 EAST 14 STREET A
## 481 PHOENIX 447 EAST 13 STREET A
## 482 PHOENIX 447 EAST 13 STREET A
## 483 PHYSICAL GRAFFITEA 96 ST MARKS PLACE A
## 484 PHYSICAL GRAFFITEA 96 ST MARKS PLACE A
## 485 PHYSICAL GRAFFITEA 96 ST MARKS PLACE A
## 486 PLADO 192 EAST 2 STREET A
## 487 PLADO 192 EAST 2 STREET A
## 488 PLANET ROSE 219 AVENUE A A
## 489 PLANET ROSE 219 AVENUE A A
## 490 PLANET ROSE 219 AVENUE A A
## 491 PLANET ROSE 219 AVENUE A A
## 492 POCO 33 AVENUE B A
## 493 POKE N' ROLL 441 EAST 9 STREET A
## 494 POKE N' ROLL 441 EAST 9 STREET A
## 495 POKE N' ROLL 441 EAST 9 STREET A
## 496 POKE N' ROLL 441 EAST 9 STREET A
## 497 POKE N' ROLL 441 EAST 9 STREET A
## 498 PYRAMID 101 AVENUE A A
## 499 PYRAMID 101 AVENUE A A
## 500 PYRAMID 101 AVENUE A A
## 501 PYRAMID 101 AVENUE A A
## 502 PYRAMID 101 AVENUE A A
## 503 PYRAMID 101 AVENUE A A
## 504 PYRAMID 101 AVENUE A A
## 505 RABBIT 122 EAST 7 STREET A
## 506 RABBIT 122 EAST 7 STREET A
## 507 RABBIT 122 EAST 7 STREET A
## 508 RADIO NUBLU 62 AVENUE C A
## 509 RADIO NUBLU 62 AVENUE C A
## 510 RAY'S CANDY STORE 113 AVENUE A A
## 511 RAY'S CANDY STORE 113 AVENUE A A
## 512 RAY'S CANDY STORE 113 AVENUE A A
## 513 RAY'S CANDY STORE 113 AVENUE A A
## 514 RAY'S CANDY STORE 113 AVENUE A A
## 515 RAY'S CANDY STORE 113 AVENUE A A
## 516 REVISION 219 AVENUE B A
## 517 ROSELLA 137 AVENUE A A
## 518 ROSELLA 137 AVENUE A A
## 519 ROSELLA 137 AVENUE A A
## 520 ROSSY'S BAKERY & COFFEE SHOP 242 EAST 3 STREET A
## 521 ROSSY'S BAKERY & COFFEE SHOP 242 EAST 3 STREET A
## 522 ROSSY'S BAKERY & COFFEE SHOP 242 EAST 3 STREET A
## 523 ROSSY'S BAKERY & COFFEE SHOP 242 EAST 3 STREET A
## 524 ROYALE 157 AVENUE C A
## 525 ROYALE 157 AVENUE C A
## 526 ROYALE 157 AVENUE C A
## 527 ROYALE 157 AVENUE C A
## 528 ROYALE 157 AVENUE C A
## 529 ROYALE 157 AVENUE C A
## 530 RUFFIAN WINE BAR 125 EAST 7 STREET A
## 531 RUFFIAN WINE BAR 125 EAST 7 STREET A
## 532 RUFFIAN WINE BAR 125 EAST 7 STREET A
## 533 RUFFIAN WINE BAR 125 EAST 7 STREET A
## 534 RUSSIAN TURKISH BATHS 268 EAST 10 STREET A
## 535 RUSSIAN TURKISH BATHS 268 EAST 10 STREET A
## 536 Raiz 120 1 AVENUE A
## 537 Raiz 120 1 AVENUE A
## 538 Raiz 120 1 AVENUE A
## 539 SABOR A MEXICO TAQUERIA 160 1 AVENUE A
## 540 SABOR A MEXICO TAQUERIA 160 1 AVENUE A
## 541 SABOR A MEXICO TAQUERIA 160 1 AVENUE A
## 542 SAHARA EAST RESTAURANT 184 1 AVENUE A
## 543 SAHARA EAST RESTAURANT 184 1 AVENUE A
## 544 SAHARA EAST RESTAURANT 184 1 AVENUE A
## 545 SAHARA EAST RESTAURANT 184 1 AVENUE A
## 546 SAHARA EAST RESTAURANT 184 1 AVENUE A
## 547 SAKE BAR SATSKO 202 EAST 7 STREET A
## 548 SAKE BAR SATSKO 202 EAST 7 STREET A
## 549 SAN LOCO 111 AVENUE C A
## 550 SECCHU YOKOTA 199 EAST 3 STREET A
## 551 SHINN EAST 119 EAST 7 STREET A
## 552 SHINN EAST 119 EAST 7 STREET A
## 553 SHINZO OMAKASE 89 EAST 2 STREET A
## 554 SING SING KARAOKE 81 AVENUE A A
## 555 SMØR 441 EAST 12 STREET A
## 556 SMØR BAKERY 437 EAST 12 STREET A
## 557 SOCIAL 68 68 AVENUE A A
## 558 SOCIAL 68 68 AVENUE A A
## 559 SOMA CAKES NYC 380 EAST 10 STREET A
## 560 SOMA CAKES NYC 380 EAST 10 STREET A
## 561 SOMTUM DER 85 AVENUE A A
## 562 SOMTUM DER 85 AVENUE A A
## 563 SOMTUM DER 85 AVENUE A A
## 564 SOMTUM DER 85 AVENUE A A
## 565 SOMTUM DER 85 AVENUE A A
## 566 SOPHIE'S 507 EAST 5 STREET A
## 567 SOPHIE'S 507 EAST 5 STREET A
## 568 SOPHIE'S 507 EAST 5 STREET A
## 569 SOPHIE'S 507 EAST 5 STREET A
## 570 SPES 413 EAST 12 STREET A
## 571 SPIKE'S 218 AVENUE A A
## 572 SPIKE'S 218 AVENUE A A
## 573 SPIKE'S 218 AVENUE A A
## 574 SPIKE'S 218 AVENUE A A
## 575 ST DYMPHNAS 117 AVENUE A A
## 576 ST DYMPHNAS 117 AVENUE A A
## 577 ST DYMPHNAS 117 AVENUE A A
## 578 ST DYMPHNAS 117 AVENUE A A
## 579 STARBUCKS 286 1 AVENUE A
## 580 STARBUCKS 286 1 AVENUE A
## 581 STARBUCKS 286 1 AVENUE A
## 582 STARBUCKS 286 1 AVENUE A
## 583 STARBUCKS 286 1 AVENUE A
## 584 STARBUCKS #48990 125 SAINT MARKS PLACE A
## 585 STARBUCKS #48990 125 SAINT MARKS PLACE A
## 586 STARBUCKS #48990 125 SAINT MARKS PLACE A
## 587 STUDIO 151 151 AVENUE C A
## 588 STUDIO 151 151 AVENUE C A
## 589 SUPERIORITY BURGER 430 EAST 9 STREET A
## 590 SUPERIORITY BURGER 430 EAST 9 STREET A
## 591 SUPERIORITY BURGER 430 EAST 9 STREET A
## 592 SUPPER 156 EAST 2 STREET A
## 593 SUPPER 156 EAST 2 STREET A
## 594 SUPPER 156 EAST 2 STREET A
## 595 SUPPER 156 EAST 2 STREET A
## 596 SUSHI DOJO 110 1 AVENUE A
## 597 SUSHI MUMI 130 SAINT MARKS PLACE A
## 598 SUSHI MUMI 130 SAINT MARKS PLACE A
## 599 SWEETIE 85 AVENUE A A
## 600 SWEETIE 85 AVENUE A A
## 601 TABERNA 97 97 SAINT MARKS PLACE A
## 602 TABERNA 97 97 SAINT MARKS PLACE A
## 603 TABERNA 97 97 SAINT MARKS PLACE A
## 604 TABERNA 97 97 SAINT MARKS PLACE A
## 605 TABERNA 97 97 SAINT MARKS PLACE A
## 606 TABERNA 97 97 SAINT MARKS PLACE A
## 607 TABERNA 97 97 SAINT MARKS PLACE A
## 608 TACOS CUAUTLA MORELOS 438 EAST 9 STREET A
## 609 TACOS CUAUTLA MORELOS 438 EAST 9 STREET A
## 610 TAKAHACHI 85 AVENUE A A
## 611 TAKAHACHI 85 AVENUE A A
## 612 TAKAHACHI 85 AVENUE A A
## 613 TAKAHACHI 85 AVENUE A A
## 614 TAKAHACHI 85 AVENUE A A
## 615 TALLGRASS BURGER 214 1 AVENUE A
## 616 TALLGRASS BURGER 214 1 AVENUE A
## 617 TALLGRASS BURGER 214 1 AVENUE A
## 618 TALLGRASS BURGER 214 1 AVENUE A
## 619 TALLGRASS BURGER 214 1 AVENUE A
## 620 TAVERNA KYCLADES 228 1 AVENUE A
## 621 TEN DEGREES 121 SAINT MARKS PLACE A
## 622 TEN DEGREES 121 SAINT MARKS PLACE A
## 623 TERRA THAI 518 EAST 6 STREET A
## 624 TERRA THAI 518 EAST 6 STREET A
## 625 TERRA THAI 518 EAST 6 STREET A
## 626 TERRA THAI 518 EAST 6 STREET A
## 627 TERRA THAI 518 EAST 6 STREET A
## 628 TERRA THAI 518 EAST 6 STREET A
## 629 THE CABINET 649 EAST 9 STREET A
## 630 THE CABINET 649 EAST 9 STREET A
## 631 THE GARRET EAST@ BORRACHITO 206 AVENUE A A
## 632 THE GARRET EAST@ BORRACHITO 206 AVENUE A A
## 633 THE GARRET EAST@ BORRACHITO 206 AVENUE A A
## 634 THE GARRET EAST@ BORRACHITO 206 AVENUE A A
## 635 THE GRAFTON PUBLIC HOUSE 126 1 AVENUE A
## 636 THE GRAYSON 16 1 AVENUE A
## 637 THE GRAYSON 16 1 AVENUE A
## 638 THE GREAT CABIN 205 EAST 4 STREET A
## 639 THE GREAT CABIN 205 EAST 4 STREET A
## 640 THE GREAT CABIN 205 EAST 4 STREET A
## 641 THE GREAT CABIN 205 EAST 4 STREET A
## 642 THE GREAT CABIN 205 EAST 4 STREET A
## 643 THE GREAT CABIN 205 EAST 4 STREET A
## 644 THE HAIRY LEMON 28 AVENUE B A
## 645 THE HAIRY LEMON 28 AVENUE B A
## 646 THE HAIRY LEMON 28 AVENUE B A
## 647 THE HAIRY LEMON 28 AVENUE B A
## 648 THE HAIRY LEMON 28 AVENUE B A
## 649 THE HARD SWALLOW 140 1 AVENUE A
## 650 THE IZAKAYA 215 EAST 4 STREET A
## 651 THE IZAKAYA 215 EAST 4 STREET A
## 652 THE IZAKAYA 215 EAST 4 STREET A
## 653 THE LIBRARY 7 AVENUE A A
## 654 THE LIBRARY 7 AVENUE A A
## 655 THE LIBRARY 7 AVENUE A A
## 656 THE PINEAPPLE CLUB 509 EAST 6 STREET A
## 657 THE PINEAPPLE CLUB 509 EAST 6 STREET A
## 658 THE PINEAPPLE CLUB 509 EAST 6 STREET A
## 659 THE PINEAPPLE CLUB 509 EAST 6 STREET A
## 660 THE PINEAPPLE CLUB 509 EAST 6 STREET A
## 661 THE ROOST 222 AVENUE B A
## 662 THE ROOST 222 AVENUE B A
## 663 THE ROOST 222 AVENUE B A
## 664 THE ROOST 222 AVENUE B A
## 665 THE ROOST 222 AVENUE B A
## 666 THE ROOST 222 AVENUE B A
## 667 THE ROOST 222 AVENUE B A
## 668 THE ROOST 222 AVENUE B A
## 669 THE ROOST 222 AVENUE B A
## 670 THE SPOTTED OWL 211 AVENUE A A
## 671 THE SPOTTED OWL 211 AVENUE A A
## 672 THE SUMMIT 133 AVENUE C A
## 673 THE WAYLAND 700 EAST 9 STREET A
## 674 THE WAYLAND 700 EAST 9 STREET A
## 675 THIRTEEN WATER 208 EAST 7 STREET A
## 676 THIRTEEN WATER 208 EAST 7 STREET A
## 677 THIRTEEN WATER 208 EAST 7 STREET A
## 678 THURSDAY KITCEHN 424 EAST 9 STREET A
## 679 THURSDAY KITCEHN 424 EAST 9 STREET A
## 680 THURSDAY KITCEHN 424 EAST 9 STREET A
## 681 THURSDAY KITCEHN 424 EAST 9 STREET A
## 682 THURSDAY KITCEHN 424 EAST 9 STREET A
## 683 THURSDAY KITCEHN 424 EAST 9 STREET A
## 684 THURSDAY KITCEHN 424 EAST 9 STREET A
## 685 TOKUYAMA CAFE 627 EAST 6 STREET A
## 686 TOKUYAMA CAFE 627 EAST 6 STREET A
## 687 TOMPKINS SQUARE BAGELS 165 AVENUE A A
## 688 TOMPKINS SQUARE BAGELS 165 AVENUE A A
## 689 TOMPKINS SQUARE BAGELS 165 AVENUE A A
## 690 TOMPKINS SQUARE BAGELS 165 AVENUE A A
## 691 TOMPKINS SQUARE BAGELS 165 AVENUE A A
## 692 TUOME 536 EAST 5 STREET A
## 693 TUOME 536 EAST 5 STREET A
## 694 TUOME 536 EAST 5 STREET A
## 695 TUOME 536 EAST 5 STREET A
## 696 TWO PERRYS 127 AVENUE C A
## 697 TWO PERRYS 127 AVENUE C A
## 698 TWO PERRYS 127 AVENUE C A
## 699 TWO PERRYS 127 AVENUE C A
## 700 VAN DA 234 EAST 4 STREET A
## 701 VAN DA 234 EAST 4 STREET A
## 702 VAN DA 234 EAST 4 STREET A
## 703 VAN DA 234 EAST 4 STREET A
## 704 VEERAY DA DHABA 222 1 AVENUE A
## 705 VEERAY DA DHABA 222 1 AVENUE A
## 706 VEERAY DA DHABA 222 1 AVENUE A
## 707 VEERAY DA DHABA 222 1 AVENUE A
## 708 VILLAGE CREPERIE 445 EAST 9 STREET A
## 709 VILLAGE CREPERIE 445 EAST 9 STREET A
## 710 VILLAGE SQUARE PIZZA 147 AVENUE A A
## 711 WESTVILLE 173 AVENUE A A
## 712 WESTVILLE 173 AVENUE A A
## 713 WESTVILLE 173 AVENUE A A
## 714 WESTVILLE 173 AVENUE A A
## 715 WHITMAN'S 406 EAST 9 STREET A
## 716 WHITMAN'S 406 EAST 9 STREET A
## 717 WHITMAN'S 406 EAST 9 STREET A
## 718 XE MAY 96 ST MARKS PLACE A
## 719 XE MAY 96 ST MARKS PLACE A
## 720 XE MAY 96 ST MARKS PLACE A
## 721 XE MAY 96 ST MARKS PLACE A
## 722 YANKEE PIZZA RESTAURANT 181 AVENUE C A
## 723 YANKEE PIZZA RESTAURANT 181 AVENUE C A
## 724 YANKEE PIZZA RESTAURANT 181 AVENUE C A
## 725 YUCA BAR & RESTAURANT 111 AVENUE A A
## 726 YUCA BAR & RESTAURANT 111 AVENUE A A
## inspection_date
## 1 2022-01-20T00:00:00.000
## 2 2022-01-20T00:00:00.000
## 3 2022-01-20T00:00:00.000
## 4 2022-01-20T00:00:00.000
## 5 2023-08-15T00:00:00.000
## 6 2023-08-15T00:00:00.000
## 7 2022-03-15T00:00:00.000
## 8 2023-05-19T00:00:00.000
## 9 2023-01-10T00:00:00.000
## 10 2023-01-10T00:00:00.000
## 11 2022-09-28T00:00:00.000
## 12 2022-09-28T00:00:00.000
## 13 2022-09-28T00:00:00.000
## 14 2022-01-13T00:00:00.000
## 15 2023-02-01T00:00:00.000
## 16 2022-01-13T00:00:00.000
## 17 2022-01-13T00:00:00.000
## 18 2023-02-01T00:00:00.000
## 19 2023-03-07T00:00:00.000
## 20 2023-03-07T00:00:00.000
## 21 2022-05-09T00:00:00.000
## 22 2022-05-09T00:00:00.000
## 23 2021-07-30T00:00:00.000
## 24 2022-09-28T00:00:00.000
## 25 2023-07-05T00:00:00.000
## 26 2023-07-05T00:00:00.000
## 27 2023-05-01T00:00:00.000
## 28 2022-09-01T00:00:00.000
## 29 2022-01-05T00:00:00.000
## 30 2022-01-05T00:00:00.000
## 31 2022-01-06T00:00:00.000
## 32 2022-01-06T00:00:00.000
## 33 2022-01-06T00:00:00.000
## 34 2022-02-23T00:00:00.000
## 35 2022-02-23T00:00:00.000
## 36 2022-02-23T00:00:00.000
## 37 2020-01-17T00:00:00.000
## 38 2022-10-23T00:00:00.000
## 39 2022-10-23T00:00:00.000
## 40 2022-10-23T00:00:00.000
## 41 2020-01-17T00:00:00.000
## 42 2020-01-17T00:00:00.000
## 43 2022-09-06T00:00:00.000
## 44 2022-09-06T00:00:00.000
## 45 2023-08-03T00:00:00.000
## 46 2023-08-03T00:00:00.000
## 47 2023-08-03T00:00:00.000
## 48 2023-04-26T00:00:00.000
## 49 2023-04-26T00:00:00.000
## 50 2022-12-28T00:00:00.000
## 51 2022-12-28T00:00:00.000
## 52 2022-12-28T00:00:00.000
## 53 2023-02-14T00:00:00.000
## 54 2023-02-14T00:00:00.000
## 55 2023-02-14T00:00:00.000
## 56 2022-09-06T00:00:00.000
## 57 2022-09-06T00:00:00.000
## 58 2020-01-03T00:00:00.000
## 59 2020-01-03T00:00:00.000
## 60 2020-01-03T00:00:00.000
## 61 2022-10-12T00:00:00.000
## 62 2022-10-12T00:00:00.000
## 63 2022-02-08T00:00:00.000
## 64 2022-03-09T00:00:00.000
## 65 2018-12-05T00:00:00.000
## 66 2018-12-05T00:00:00.000
## 67 2020-02-10T00:00:00.000
## 68 2020-02-10T00:00:00.000
## 69 2023-01-30T00:00:00.000
## 70 2023-01-30T00:00:00.000
## 71 2023-03-01T00:00:00.000
## 72 2023-03-01T00:00:00.000
## 73 2021-07-21T00:00:00.000
## 74 2021-12-03T00:00:00.000
## 75 2021-12-03T00:00:00.000
## 76 2023-11-16T00:00:00.000
## 77 2023-11-16T00:00:00.000
## 78 2023-11-16T00:00:00.000
## 79 2017-09-29T00:00:00.000
## 80 2019-05-03T00:00:00.000
## 81 2019-05-03T00:00:00.000
## 82 2016-05-20T00:00:00.000
## 83 2016-05-20T00:00:00.000
## 84 2017-09-29T00:00:00.000
## 85 2019-05-03T00:00:00.000
## 86 2017-09-29T00:00:00.000
## 87 2022-06-14T00:00:00.000
## 88 2022-06-14T00:00:00.000
## 89 2022-06-14T00:00:00.000
## 90 2023-05-31T00:00:00.000
## 91 2022-07-28T00:00:00.000
## 92 2022-07-28T00:00:00.000
## 93 2019-10-08T00:00:00.000
## 94 2019-10-08T00:00:00.000
## 95 2022-07-28T00:00:00.000
## 96 2022-11-18T00:00:00.000
## 97 2022-11-18T00:00:00.000
## 98 2022-11-18T00:00:00.000
## 99 2021-12-15T00:00:00.000
## 100 2023-10-11T00:00:00.000
## 101 2021-12-15T00:00:00.000
## 102 2023-10-11T00:00:00.000
## 103 2023-04-13T00:00:00.000
## 104 2023-04-13T00:00:00.000
## 105 2023-04-13T00:00:00.000
## 106 2022-09-28T00:00:00.000
## 107 2023-01-04T00:00:00.000
## 108 2023-01-04T00:00:00.000
## 109 2023-01-04T00:00:00.000
## 110 2020-01-08T00:00:00.000
## 111 2022-12-28T00:00:00.000
## 112 2020-01-08T00:00:00.000
## 113 2022-12-28T00:00:00.000
## 114 2020-01-08T00:00:00.000
## 115 2023-04-16T00:00:00.000
## 116 2023-04-16T00:00:00.000
## 117 2023-04-16T00:00:00.000
## 118 2022-12-06T00:00:00.000
## 119 2022-12-06T00:00:00.000
## 120 2021-12-01T00:00:00.000
## 121 2021-12-01T00:00:00.000
## 122 2022-11-12T00:00:00.000
## 123 2022-11-12T00:00:00.000
## 124 2022-11-12T00:00:00.000
## 125 2022-11-12T00:00:00.000
## 126 2023-01-03T00:00:00.000
## 127 2023-01-03T00:00:00.000
## 128 2023-09-06T00:00:00.000
## 129 2022-01-13T00:00:00.000
## 130 2023-09-06T00:00:00.000
## 131 2022-04-27T00:00:00.000
## 132 2023-01-24T00:00:00.000
## 133 2023-01-24T00:00:00.000
## 134 2023-04-11T00:00:00.000
## 135 2022-03-29T00:00:00.000
## 136 2022-03-29T00:00:00.000
## 137 2023-04-11T00:00:00.000
## 138 2023-04-11T00:00:00.000
## 139 2023-09-28T00:00:00.000
## 140 2023-09-28T00:00:00.000
## 141 2023-10-16T00:00:00.000
## 142 2022-03-02T00:00:00.000
## 143 2023-10-16T00:00:00.000
## 144 2023-10-16T00:00:00.000
## 145 2022-03-02T00:00:00.000
## 146 2022-03-16T00:00:00.000
## 147 2022-03-16T00:00:00.000
## 148 2023-05-31T00:00:00.000
## 149 2023-05-31T00:00:00.000
## 150 2023-05-13T00:00:00.000
## 151 2023-05-13T00:00:00.000
## 152 2022-01-19T00:00:00.000
## 153 2022-01-19T00:00:00.000
## 154 2022-01-19T00:00:00.000
## 155 2023-05-09T00:00:00.000
## 156 2023-05-09T00:00:00.000
## 157 2022-04-07T00:00:00.000
## 158 2021-07-29T00:00:00.000
## 159 2022-02-08T00:00:00.000
## 160 2020-01-29T00:00:00.000
## 161 2020-01-29T00:00:00.000
## 162 2022-03-16T00:00:00.000
## 163 2022-03-16T00:00:00.000
## 164 2022-03-16T00:00:00.000
## 165 2023-01-27T00:00:00.000
## 166 2022-01-20T00:00:00.000
## 167 2022-10-31T00:00:00.000
## 168 2022-03-15T00:00:00.000
## 169 2022-03-15T00:00:00.000
## 170 2022-06-08T00:00:00.000
## 171 2022-10-18T00:00:00.000
## 172 2022-01-19T00:00:00.000
## 173 2023-06-16T00:00:00.000
## 174 2022-01-25T00:00:00.000
## 175 2022-01-25T00:00:00.000
## 176 2022-01-25T00:00:00.000
## 177 2022-08-02T00:00:00.000
## 178 2022-08-25T00:00:00.000
## 179 2023-10-24T00:00:00.000
## 180 2022-08-25T00:00:00.000
## 181 2023-01-20T00:00:00.000
## 182 2022-01-05T00:00:00.000
## 183 2022-12-21T00:00:00.000
## 184 2022-12-21T00:00:00.000
## 185 2022-01-05T00:00:00.000
## 186 2022-12-21T00:00:00.000
## 187 2022-10-04T00:00:00.000
## 188 2023-04-26T00:00:00.000
## 189 2022-10-04T00:00:00.000
## 190 2023-04-26T00:00:00.000
## 191 2022-01-19T00:00:00.000
## 192 2023-02-01T00:00:00.000
## 193 2022-01-19T00:00:00.000
## 194 2023-02-01T00:00:00.000
## 195 2022-03-16T00:00:00.000
## 196 2023-06-02T00:00:00.000
## 197 2023-06-02T00:00:00.000
## 198 2023-05-04T00:00:00.000
## 199 2023-05-04T00:00:00.000
## 200 2023-06-06T00:00:00.000
## 201 2023-06-06T00:00:00.000
## 202 2022-05-03T00:00:00.000
## 203 2023-02-23T00:00:00.000
## 204 2023-02-23T00:00:00.000
## 205 2021-12-02T00:00:00.000
## 206 2021-12-02T00:00:00.000
## 207 2023-02-23T00:00:00.000
## 208 2023-01-31T00:00:00.000
## 209 2023-01-31T00:00:00.000
## 210 2022-01-24T00:00:00.000
## 211 2022-01-24T00:00:00.000
## 212 2022-03-04T00:00:00.000
## 213 2022-03-04T00:00:00.000
## 214 2022-03-04T00:00:00.000
## 215 2023-05-12T00:00:00.000
## 216 2023-05-12T00:00:00.000
## 217 2023-03-29T00:00:00.000
## 218 2022-04-27T00:00:00.000
## 219 2022-04-27T00:00:00.000
## 220 2022-04-27T00:00:00.000
## 221 2023-03-29T00:00:00.000
## 222 2023-03-29T00:00:00.000
## 223 2022-12-01T00:00:00.000
## 224 2023-06-22T00:00:00.000
## 225 2023-06-22T00:00:00.000
## 226 2022-04-26T00:00:00.000
## 227 2022-04-26T00:00:00.000
## 228 2023-06-22T00:00:00.000
## 229 2023-08-22T00:00:00.000
## 230 2023-08-22T00:00:00.000
## 231 2022-02-18T00:00:00.000
## 232 2022-02-18T00:00:00.000
## 233 2022-02-18T00:00:00.000
## 234 2023-02-08T00:00:00.000
## 235 2021-11-10T00:00:00.000
## 236 2021-11-10T00:00:00.000
## 237 2021-11-10T00:00:00.000
## 238 2023-02-08T00:00:00.000
## 239 2023-02-08T00:00:00.000
## 240 2022-07-14T00:00:00.000
## 241 2022-07-14T00:00:00.000
## 242 2022-07-14T00:00:00.000
## 243 2020-02-03T00:00:00.000
## 244 2022-07-14T00:00:00.000
## 245 2022-04-14T00:00:00.000
## 246 2022-04-14T00:00:00.000
## 247 2022-04-14T00:00:00.000
## 248 2023-04-11T00:00:00.000
## 249 2023-04-11T00:00:00.000
## 250 2022-07-28T00:00:00.000
## 251 2022-05-02T00:00:00.000
## 252 2022-05-02T00:00:00.000
## 253 2022-05-02T00:00:00.000
## 254 2022-12-28T00:00:00.000
## 255 2022-12-28T00:00:00.000
## 256 2022-12-28T00:00:00.000
## 257 2022-09-13T00:00:00.000
## 258 2022-09-13T00:00:00.000
## 259 2023-02-14T00:00:00.000
## 260 2023-02-14T00:00:00.000
## 261 2023-02-14T00:00:00.000
## 262 2023-03-31T00:00:00.000
## 263 2023-03-31T00:00:00.000
## 264 2022-03-08T00:00:00.000
## 265 2022-03-08T00:00:00.000
## 266 2022-03-08T00:00:00.000
## 267 2023-03-08T00:00:00.000
## 268 2023-03-08T00:00:00.000
## 269 2021-10-20T00:00:00.000
## 270 2021-10-20T00:00:00.000
## 271 2021-10-20T00:00:00.000
## 272 2022-05-31T00:00:00.000
## 273 2022-05-31T00:00:00.000
## 274 2022-05-31T00:00:00.000
## 275 2022-09-06T00:00:00.000
## 276 2022-09-06T00:00:00.000
## 277 2022-09-06T00:00:00.000
## 278 2023-11-15T00:00:00.000
## 279 2023-04-27T00:00:00.000
## 280 2023-04-27T00:00:00.000
## 281 2023-04-27T00:00:00.000
## 282 2022-09-06T00:00:00.000
## 283 2020-03-13T00:00:00.000
## 284 2022-09-06T00:00:00.000
## 285 2020-03-13T00:00:00.000
## 286 2020-03-13T00:00:00.000
## 287 2023-11-16T00:00:00.000
## 288 2023-11-16T00:00:00.000
## 289 2023-11-16T00:00:00.000
## 290 2022-07-20T00:00:00.000
## 291 2022-07-20T00:00:00.000
## 292 2023-06-20T00:00:00.000
## 293 2022-01-25T00:00:00.000
## 294 2023-06-20T00:00:00.000
## 295 2021-08-26T00:00:00.000
## 296 2021-08-26T00:00:00.000
## 297 2020-03-13T00:00:00.000
## 298 2023-02-03T00:00:00.000
## 299 2020-03-13T00:00:00.000
## 300 2023-11-16T00:00:00.000
## 301 2022-07-26T00:00:00.000
## 302 2023-11-16T00:00:00.000
## 303 2022-07-26T00:00:00.000
## 304 2022-04-11T00:00:00.000
## 305 2023-04-13T00:00:00.000
## 306 2023-04-13T00:00:00.000
## 307 2022-04-11T00:00:00.000
## 308 2023-01-24T00:00:00.000
## 309 2023-01-24T00:00:00.000
## 310 2023-01-24T00:00:00.000
## 311 2023-03-20T00:00:00.000
## 312 2022-02-08T00:00:00.000
## 313 2023-03-20T00:00:00.000
## 314 2023-08-01T00:00:00.000
## 315 2023-08-01T00:00:00.000
## 316 2023-03-18T00:00:00.000
## 317 2022-03-29T00:00:00.000
## 318 2022-03-29T00:00:00.000
## 319 2023-06-20T00:00:00.000
## 320 2022-03-09T00:00:00.000
## 321 2023-06-20T00:00:00.000
## 322 2022-03-09T00:00:00.000
## 323 2023-06-20T00:00:00.000
## 324 2022-06-08T00:00:00.000
## 325 2022-06-08T00:00:00.000
## 326 2022-06-08T00:00:00.000
## 327 2023-02-15T00:00:00.000
## 328 2022-06-08T00:00:00.000
## 329 2023-02-03T00:00:00.000
## 330 2023-02-03T00:00:00.000
## 331 2023-02-23T00:00:00.000
## 332 2022-03-02T00:00:00.000
## 333 2022-03-02T00:00:00.000
## 334 2023-02-23T00:00:00.000
## 335 2023-02-23T00:00:00.000
## 336 2023-02-23T00:00:00.000
## 337 2022-03-02T00:00:00.000
## 338 2022-11-30T00:00:00.000
## 339 2022-03-02T00:00:00.000
## 340 2022-03-02T00:00:00.000
## 341 2022-11-30T00:00:00.000
## 342 2022-11-30T00:00:00.000
## 343 2019-09-23T00:00:00.000
## 344 2022-05-31T00:00:00.000
## 345 2022-09-01T00:00:00.000
## 346 2022-09-01T00:00:00.000
## 347 2022-07-20T00:00:00.000
## 348 2022-04-26T00:00:00.000
## 349 2022-01-13T00:00:00.000
## 350 2022-08-23T00:00:00.000
## 351 2023-03-18T00:00:00.000
## 352 2023-03-18T00:00:00.000
## 353 2022-01-19T00:00:00.000
## 354 2022-01-19T00:00:00.000
## 355 2022-05-11T00:00:00.000
## 356 2023-06-22T00:00:00.000
## 357 2023-06-22T00:00:00.000
## 358 2023-06-22T00:00:00.000
## 359 2022-04-14T00:00:00.000
## 360 2023-07-31T00:00:00.000
## 361 2022-04-14T00:00:00.000
## 362 2022-04-14T00:00:00.000
## 363 2023-08-15T00:00:00.000
## 364 2023-08-15T00:00:00.000
## 365 2022-08-25T00:00:00.000
## 366 2022-08-25T00:00:00.000
## 367 2021-10-18T00:00:00.000
## 368 2023-03-01T00:00:00.000
## 369 2023-03-01T00:00:00.000
## 370 2023-03-01T00:00:00.000
## 371 2021-10-18T00:00:00.000
## 372 2023-06-02T00:00:00.000
## 373 2022-03-01T00:00:00.000
## 374 2023-06-02T00:00:00.000
## 375 2023-06-02T00:00:00.000
## 376 2022-09-13T00:00:00.000
## 377 2022-09-13T00:00:00.000
## 378 2022-10-31T00:00:00.000
## 379 2022-03-02T00:00:00.000
## 380 2022-03-02T00:00:00.000
## 381 2023-03-08T00:00:00.000
## 382 2023-03-08T00:00:00.000
## 383 2022-03-02T00:00:00.000
## 384 2023-02-08T00:00:00.000
## 385 2023-02-08T00:00:00.000
## 386 2023-02-08T00:00:00.000
## 387 2022-06-11T00:00:00.000
## 388 2022-06-11T00:00:00.000
## 389 2022-02-02T00:00:00.000
## 390 2022-02-02T00:00:00.000
## 391 2022-02-02T00:00:00.000
## 392 2023-04-11T00:00:00.000
## 393 2022-06-06T00:00:00.000
## 394 2023-04-11T00:00:00.000
## 395 2023-10-19T00:00:00.000
## 396 2022-03-02T00:00:00.000
## 397 2023-10-19T00:00:00.000
## 398 2022-03-02T00:00:00.000
## 399 2019-03-20T00:00:00.000
## 400 2022-02-08T00:00:00.000
## 401 2019-03-20T00:00:00.000
## 402 2022-02-08T00:00:00.000
## 403 2019-03-20T00:00:00.000
## 404 2023-02-17T00:00:00.000
## 405 2023-02-17T00:00:00.000
## 406 2023-02-17T00:00:00.000
## 407 2022-12-01T00:00:00.000
## 408 2022-12-01T00:00:00.000
## 409 2022-12-28T00:00:00.000
## 410 2022-12-28T00:00:00.000
## 411 2023-05-12T00:00:00.000
## 412 2022-12-28T00:00:00.000
## 413 2023-05-12T00:00:00.000
## 414 2023-05-12T00:00:00.000
## 415 2022-12-28T00:00:00.000
## 416 2023-05-12T00:00:00.000
## 417 2022-08-25T00:00:00.000
## 418 2022-05-03T00:00:00.000
## 419 2023-06-02T00:00:00.000
## 420 2022-05-03T00:00:00.000
## 421 2020-02-21T00:00:00.000
## 422 2020-02-21T00:00:00.000
## 423 2023-04-13T00:00:00.000
## 424 2022-11-18T00:00:00.000
## 425 2022-03-31T00:00:00.000
## 426 2023-04-13T00:00:00.000
## 427 2022-03-31T00:00:00.000
## 428 2023-10-10T00:00:00.000
## 429 2022-03-02T00:00:00.000
## 430 2022-03-02T00:00:00.000
## 431 2023-10-10T00:00:00.000
## 432 2022-03-02T00:00:00.000
## 433 2023-10-10T00:00:00.000
## 434 2022-01-06T00:00:00.000
## 435 2022-01-06T00:00:00.000
## 436 2022-07-20T00:00:00.000
## 437 2019-12-03T00:00:00.000
## 438 2019-12-03T00:00:00.000
## 439 2022-07-20T00:00:00.000
## 440 2021-11-09T00:00:00.000
## 441 2021-11-09T00:00:00.000
## 442 2022-11-03T00:00:00.000
## 443 2022-11-03T00:00:00.000
## 444 2022-11-03T00:00:00.000
## 445 2021-11-09T00:00:00.000
## 446 2022-01-05T00:00:00.000
## 447 2023-03-07T00:00:00.000
## 448 2023-03-07T00:00:00.000
## 449 2022-03-08T00:00:00.000
## 450 2022-03-08T00:00:00.000
## 451 2023-04-13T00:00:00.000
## 452 2023-04-13T00:00:00.000
## 453 2023-05-31T00:00:00.000
## 454 2022-02-08T00:00:00.000
## 455 2022-02-08T00:00:00.000
## 456 2022-03-04T00:00:00.000
## 457 2023-02-23T00:00:00.000
## 458 2023-01-27T00:00:00.000
## 459 2021-07-20T00:00:00.000
## 460 2021-07-20T00:00:00.000
## 461 2023-02-23T00:00:00.000
## 462 2023-03-03T00:00:00.000
## 463 2020-01-21T00:00:00.000
## 464 2020-01-21T00:00:00.000
## 465 2022-09-13T00:00:00.000
## 466 2022-03-10T00:00:00.000
## 467 2022-03-10T00:00:00.000
## 468 2022-12-01T00:00:00.000
## 469 2022-12-01T00:00:00.000
## 470 2022-03-09T00:00:00.000
## 471 2022-03-09T00:00:00.000
## 472 2023-03-18T00:00:00.000
## 473 2022-12-01T00:00:00.000
## 474 2022-12-01T00:00:00.000
## 475 2023-05-12T00:00:00.000
## 476 2022-04-20T00:00:00.000
## 477 2022-04-20T00:00:00.000
## 478 2022-04-20T00:00:00.000
## 479 2023-05-12T00:00:00.000
## 480 2022-04-20T00:00:00.000
## 481 2023-03-07T00:00:00.000
## 482 2023-03-07T00:00:00.000
## 483 2021-08-17T00:00:00.000
## 484 2022-10-18T00:00:00.000
## 485 2022-10-18T00:00:00.000
## 486 2022-01-19T00:00:00.000
## 487 2022-01-19T00:00:00.000
## 488 2020-03-12T00:00:00.000
## 489 2022-09-06T00:00:00.000
## 490 2022-09-06T00:00:00.000
## 491 2020-03-12T00:00:00.000
## 492 2023-03-25T00:00:00.000
## 493 2023-05-31T00:00:00.000
## 494 2023-05-31T00:00:00.000
## 495 2022-04-21T00:00:00.000
## 496 2022-04-21T00:00:00.000
## 497 2023-05-31T00:00:00.000
## 498 2019-08-30T00:00:00.000
## 499 2019-08-30T00:00:00.000
## 500 2018-03-03T00:00:00.000
## 501 2019-08-30T00:00:00.000
## 502 2018-03-03T00:00:00.000
## 503 2020-02-20T00:00:00.000
## 504 2019-08-30T00:00:00.000
## 505 2023-02-04T00:00:00.000
## 506 2023-02-04T00:00:00.000
## 507 2023-02-04T00:00:00.000
## 508 2023-01-08T00:00:00.000
## 509 2023-01-08T00:00:00.000
## 510 2021-12-08T00:00:00.000
## 511 2023-03-31T00:00:00.000
## 512 2023-03-31T00:00:00.000
## 513 2021-12-08T00:00:00.000
## 514 2023-03-31T00:00:00.000
## 515 2023-03-31T00:00:00.000
## 516 2023-03-03T00:00:00.000
## 517 2023-02-02T00:00:00.000
## 518 2023-02-02T00:00:00.000
## 519 2023-02-02T00:00:00.000
## 520 2021-12-23T00:00:00.000
## 521 2021-12-23T00:00:00.000
## 522 2022-10-18T00:00:00.000
## 523 2022-10-18T00:00:00.000
## 524 2019-12-04T00:00:00.000
## 525 2022-07-26T00:00:00.000
## 526 2022-07-26T00:00:00.000
## 527 2022-07-26T00:00:00.000
## 528 2019-12-04T00:00:00.000
## 529 2019-12-04T00:00:00.000
## 530 2023-07-11T00:00:00.000
## 531 2022-07-26T00:00:00.000
## 532 2023-07-11T00:00:00.000
## 533 2023-07-11T00:00:00.000
## 534 2022-09-01T00:00:00.000
## 535 2022-09-01T00:00:00.000
## 536 2022-04-20T00:00:00.000
## 537 2022-04-20T00:00:00.000
## 538 2022-04-20T00:00:00.000
## 539 2023-02-08T00:00:00.000
## 540 2023-02-08T00:00:00.000
## 541 2022-01-19T00:00:00.000
## 542 2023-10-03T00:00:00.000
## 543 2022-04-21T00:00:00.000
## 544 2023-10-03T00:00:00.000
## 545 2022-04-21T00:00:00.000
## 546 2022-04-21T00:00:00.000
## 547 2023-01-31T00:00:00.000
## 548 2020-02-18T00:00:00.000
## 549 2022-09-07T00:00:00.000
## 550 2023-03-18T00:00:00.000
## 551 2023-10-11T00:00:00.000
## 552 2023-10-11T00:00:00.000
## 553 2023-04-28T00:00:00.000
## 554 2022-09-13T00:00:00.000
## 555 2022-04-08T00:00:00.000
## 556 2023-08-03T00:00:00.000
## 557 2023-03-30T00:00:00.000
## 558 2023-03-30T00:00:00.000
## 559 2022-11-03T00:00:00.000
## 560 2021-11-10T00:00:00.000
## 561 2019-06-18T00:00:00.000
## 562 2022-05-10T00:00:00.000
## 563 2022-05-10T00:00:00.000
## 564 2019-06-18T00:00:00.000
## 565 2019-12-03T00:00:00.000
## 566 2022-04-11T00:00:00.000
## 567 2023-03-29T00:00:00.000
## 568 2022-04-11T00:00:00.000
## 569 2023-03-29T00:00:00.000
## 570 2022-02-01T00:00:00.000
## 571 2022-05-02T00:00:00.000
## 572 2022-05-02T00:00:00.000
## 573 2022-05-02T00:00:00.000
## 574 2022-05-02T00:00:00.000
## 575 2022-03-09T00:00:00.000
## 576 2022-03-09T00:00:00.000
## 577 2022-03-09T00:00:00.000
## 578 2022-03-09T00:00:00.000
## 579 2023-09-07T00:00:00.000
## 580 2021-12-01T00:00:00.000
## 581 2022-09-15T00:00:00.000
## 582 2021-12-01T00:00:00.000
## 583 2023-09-07T00:00:00.000
## 584 2021-08-11T00:00:00.000
## 585 2021-08-11T00:00:00.000
## 586 2023-08-29T00:00:00.000
## 587 2023-03-08T00:00:00.000
## 588 2023-03-08T00:00:00.000
## 589 2022-08-08T00:00:00.000
## 590 2020-02-06T00:00:00.000
## 591 2020-02-06T00:00:00.000
## 592 2023-05-09T00:00:00.000
## 593 2023-05-09T00:00:00.000
## 594 2023-05-09T00:00:00.000
## 595 2023-05-09T00:00:00.000
## 596 2023-01-29T00:00:00.000
## 597 2022-11-12T00:00:00.000
## 598 2022-11-12T00:00:00.000
## 599 2023-04-27T00:00:00.000
## 600 2023-04-27T00:00:00.000
## 601 2017-06-30T00:00:00.000
## 602 2019-06-20T00:00:00.000
## 603 2017-06-30T00:00:00.000
## 604 2018-06-16T00:00:00.000
## 605 2018-06-16T00:00:00.000
## 606 2017-06-30T00:00:00.000
## 607 2019-06-20T00:00:00.000
## 608 2023-01-31T00:00:00.000
## 609 2023-01-31T00:00:00.000
## 610 2020-01-29T00:00:00.000
## 611 2023-01-27T00:00:00.000
## 612 2020-01-29T00:00:00.000
## 613 2023-01-27T00:00:00.000
## 614 2020-01-29T00:00:00.000
## 615 2022-01-25T00:00:00.000
## 616 2022-12-15T00:00:00.000
## 617 2022-12-15T00:00:00.000
## 618 2022-01-25T00:00:00.000
## 619 2022-12-15T00:00:00.000
## 620 2022-09-01T00:00:00.000
## 621 2023-06-03T00:00:00.000
## 622 2023-06-03T00:00:00.000
## 623 2021-11-24T00:00:00.000
## 624 2022-12-15T00:00:00.000
## 625 2022-12-15T00:00:00.000
## 626 2022-12-15T00:00:00.000
## 627 2021-11-24T00:00:00.000
## 628 2021-11-24T00:00:00.000
## 629 2022-12-28T00:00:00.000
## 630 2022-12-28T00:00:00.000
## 631 2022-01-19T00:00:00.000
## 632 2022-01-19T00:00:00.000
## 633 2022-01-19T00:00:00.000
## 634 2022-01-19T00:00:00.000
## 635 2022-03-29T00:00:00.000
## 636 2023-02-28T00:00:00.000
## 637 2023-02-28T00:00:00.000
## 638 2023-05-31T00:00:00.000
## 639 2022-06-01T00:00:00.000
## 640 2023-05-31T00:00:00.000
## 641 2022-06-01T00:00:00.000
## 642 2022-06-01T00:00:00.000
## 643 2022-06-01T00:00:00.000
## 644 2022-03-01T00:00:00.000
## 645 2023-06-03T00:00:00.000
## 646 2023-06-03T00:00:00.000
## 647 2023-06-03T00:00:00.000
## 648 2023-06-03T00:00:00.000
## 649 2022-11-03T00:00:00.000
## 650 2021-12-08T00:00:00.000
## 651 2021-12-08T00:00:00.000
## 652 2021-12-08T00:00:00.000
## 653 2021-08-03T00:00:00.000
## 654 2022-10-18T00:00:00.000
## 655 2022-10-18T00:00:00.000
## 656 2021-11-30T00:00:00.000
## 657 2023-03-08T00:00:00.000
## 658 2023-03-08T00:00:00.000
## 659 2023-03-08T00:00:00.000
## 660 2021-11-30T00:00:00.000
## 661 2022-09-12T00:00:00.000
## 662 2023-02-15T00:00:00.000
## 663 2022-09-12T00:00:00.000
## 664 2022-09-12T00:00:00.000
## 665 2022-09-12T00:00:00.000
## 666 2023-02-15T00:00:00.000
## 667 2022-09-12T00:00:00.000
## 668 2022-09-12T00:00:00.000
## 669 2022-09-12T00:00:00.000
## 670 2022-09-01T00:00:00.000
## 671 2022-09-01T00:00:00.000
## 672 2022-03-15T00:00:00.000
## 673 2022-10-04T00:00:00.000
## 674 2022-10-04T00:00:00.000
## 675 2023-08-22T00:00:00.000
## 676 2023-08-22T00:00:00.000
## 677 2023-08-22T00:00:00.000
## 678 2023-06-03T00:00:00.000
## 679 2022-03-15T00:00:00.000
## 680 2022-03-15T00:00:00.000
## 681 2023-06-03T00:00:00.000
## 682 2022-03-15T00:00:00.000
## 683 2023-06-03T00:00:00.000
## 684 2023-06-03T00:00:00.000
## 685 2023-06-23T00:00:00.000
## 686 2022-04-28T00:00:00.000
## 687 2023-04-03T00:00:00.000
## 688 2023-04-03T00:00:00.000
## 689 2023-04-03T00:00:00.000
## 690 2022-02-08T00:00:00.000
## 691 2022-02-08T00:00:00.000
## 692 2020-01-28T00:00:00.000
## 693 2022-09-27T00:00:00.000
## 694 2022-09-27T00:00:00.000
## 695 2020-01-28T00:00:00.000
## 696 2023-03-08T00:00:00.000
## 697 2021-12-03T00:00:00.000
## 698 2021-12-03T00:00:00.000
## 699 2023-03-08T00:00:00.000
## 700 2022-08-02T00:00:00.000
## 701 2019-10-22T00:00:00.000
## 702 2019-10-22T00:00:00.000
## 703 2022-08-02T00:00:00.000
## 704 2022-12-19T00:00:00.000
## 705 2022-12-19T00:00:00.000
## 706 2022-12-19T00:00:00.000
## 707 2022-12-19T00:00:00.000
## 708 2022-08-10T00:00:00.000
## 709 2022-08-10T00:00:00.000
## 710 2023-10-11T00:00:00.000
## 711 2022-03-29T00:00:00.000
## 712 2022-03-29T00:00:00.000
## 713 2023-05-01T00:00:00.000
## 714 2023-05-01T00:00:00.000
## 715 2023-02-14T00:00:00.000
## 716 2023-02-14T00:00:00.000
## 717 2023-02-14T00:00:00.000
## 718 2021-07-27T00:00:00.000
## 719 2023-02-28T00:00:00.000
## 720 2023-02-28T00:00:00.000
## 721 2021-07-27T00:00:00.000
## 722 2022-04-07T00:00:00.000
## 723 2022-04-07T00:00:00.000
## 724 2022-04-07T00:00:00.000
## 725 2021-08-26T00:00:00.000
## 726 2021-08-26T00:00:00.000#Attempt a Plotly boxplot
# mutate to reorder "street" based on the median grade
nyc_inspections_zipcode_clean_df <- nyc_inspections_zipcode_clean_df %>%
mutate(street = fct_reorder(street, grade, .fun = median))## Warning: There were 15 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `street = fct_reorder(street, grade, .fun = median)`.
## Caused by warning in `mean.default()`:
## ! argument is not numeric or logical: returning NA
## ℹ Run `dplyr::last_dplyr_warnings()` to see the 14 remaining warnings.# Create a Plotly boxplot for "grade" by "street"
boxplot <- nyc_inspections_zipcode_clean_df %>%
plot_ly(y = ~grade, color = ~street, type = "box", colors = "viridis")
# Show the plot
boxplotThis boxplot was more informative than the scatterplot
#bar chart of number of places in zipcode 10009 with restaurants in each category
# Count the occurrences of each grade
grade_counts <- nyc_inspections_zipcode_clean_df %>%
count(grade)
# Create a Plotly barchart
barchart <- grade_counts %>%
plot_ly(x = ~grade, y = ~n, type = "bar", marker = list(color = "skyblue"))
# Show the barchart
barchartThe bar chart is the most informative - showing me taht in my neighborhood, a small proportion of restaurants have inspection grades less than an A. Comforting.